<?php session_start();?>
<?php include('includes/header.php');?>
<?php include("../includes/config.php"); ?>

  <div  id="main" role="main">
  
  <?php if (isset($_POST['elm1'])){
		$query = "UPDATE cities
					   SET article_text  =  '".$_POST['elm1']."',
					   article = 1
					   where id_city = ".$_GET['stad']." and id_country= ". $_GET['land'];
						
		$exc = mysql_query($query) or die (mysql_error());
		echo "Artikel toegevoegd";
		header('Location: steden.php',2);
  }
  else{
  ?>
			<!-- Load jQuery -->
	<script type="text/javascript" src="http://www.google.com/jsapi"></script>
	<script type="text/javascript">
		google.load("jquery", "1");
	</script>

	<!-- Load TinyMCE -->
	<script type="text/javascript" src="jscripts/tiny_mce/jquery.tinymce.js"></script>
	<script type="text/javascript">
		$().ready(function() {
			$('textarea.tinymce').tinymce({
				// Location of TinyMCE script
				script_url : 'jscripts/tiny_mce/tiny_mce.js',

				// General options
				theme : "advanced",
				plugins : "autolink,lists,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,advlist",

				// Theme options
				theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",
				theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",
				theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",
				theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak",
				theme_advanced_toolbar_location : "top",
				theme_advanced_toolbar_align : "left",
				theme_advanced_statusbar_location : "bottom",
				theme_advanced_resizing : true,

				// Example content CSS (should be your site CSS)
				content_css : "css/content.css",

				// Drop lists for link/image/media/template dialogs
				template_external_list_url : "lists/template_list.js",
				external_link_list_url : "lists/link_list.js",
				external_image_list_url : "lists/image_list.js",
				media_external_list_url : "lists/media_list.js",

				// Replace values for the template plugin
				template_replace_values : {
					username : "Some User",
					staffid : "991234"
				}
			});
		});
	</script>
	<!-- /TinyMCE -->

	</head>
	<body>

	<form method="post" action="#">
		<div>
		<?php 
				 
				  $q = "select city_name,article,article_text from cities where id_city = ".$_GET['stad']." and id_country= ". $_GET['land'] ;
				  $res = mysql_fetch_array(mysql_query($q)); 
				  
				  if($res['article'] == 1){
				  ?>
				  
				  <h2>Pagina wijzigen voor <?php echo $res['city_name']; ?></h2>

			<!-- Gets replaced with TinyMCE, remember HTML in a textarea should be encoded -->
			<div>
				<textarea id="elm1" name="elm1" rows="15" cols="80" style="width: 80%" class="tinymce">
					<?php echo $res['article_text']; ?>
				</textarea>
			</div>

			<!-- Some integration calls 
			<a href="javascript:;" onclick="$('#elm1').tinymce().show();return false;">[Show]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().hide();return false;">[Hide]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().execCommand('Bold');return false;">[Bold]</a>
			<a href="javascript:;" onclick="alert($('#elm1').html());return false;">[Get contents]</a>
			<a href="javascript:;" onclick="alert($('#elm1').tinymce().selection.getContent());return false;">[Get selected HTML]</a>
			<a href="javascript:;" onclick="alert($('#elm1').tinymce().selection.getContent({format : 'text'}));return false;">[Get selected text]</a>
			<a href="javascript:;" onclick="alert($('#elm1').tinymce().selection.getNode().nodeName);return false;">[Get selected element]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().execCommand('mceInsertContent',false,'<b>Hello world!!</b>');return false;">[Insert HTML]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().execCommand('mceReplaceContent',false,'<b>{$selection}</b>');return false;">[Replace selection]</a>
	-->
			<br />
			<input type="submit" name="save" value="Bevestig" />
			<input type="reset" name="reset" value="Reset" />
		</div>
				  
				  <?php
				  
				  
				  }else{
				  
				  ?>

			<h2>Pagina maken voor <?php echo $res['city_name']; ?></h2>

			<!-- Gets replaced with TinyMCE, remember HTML in a textarea should be encoded -->
			<div>
				<textarea id="elm1" name="elm1" rows="15" cols="80" style="width: 80%" class="tinymce">
					
				</textarea>
			</div>

			<!-- Some integration calls 
			<a href="javascript:;" onclick="$('#elm1').tinymce().show();return false;">[Show]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().hide();return false;">[Hide]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().execCommand('Bold');return false;">[Bold]</a>
			<a href="javascript:;" onclick="alert($('#elm1').html());return false;">[Get contents]</a>
			<a href="javascript:;" onclick="alert($('#elm1').tinymce().selection.getContent());return false;">[Get selected HTML]</a>
			<a href="javascript:;" onclick="alert($('#elm1').tinymce().selection.getContent({format : 'text'}));return false;">[Get selected text]</a>
			<a href="javascript:;" onclick="alert($('#elm1').tinymce().selection.getNode().nodeName);return false;">[Get selected element]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().execCommand('mceInsertContent',false,'<b>Hello world!!</b>');return false;">[Insert HTML]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().execCommand('mceReplaceContent',false,'<b>{$selection}</b>');return false;">[Replace selection]</a>
	-->
			<br />
			<input type="submit" name="save" value="Bevestig" />
			<input type="reset" name="reset" value="Reset" />
		</div>
	</form>
	<script type="text/javascript">
	if (document.location.protocol == 'file:') {
		alert("The examples might not work properly on the local file system due to security settings in your browser. Please use a real webserver.");
	}
	</script>
<?php }
	} ?>
  </div>

  
  <?php include('includes/footer.php');?>